inherited dtmck_ProductStockDetail: Tdtmck_ProductStockDetail
  OldCreateOrder = True
  Left = 405
  Top = 332
  Height = 414
  Width = 659
  inherited adsMaster: TADODataSet
    CursorType = ctStatic
    CommandText = 
      'Exec ck_rpt_ProductStockDetail'#13#10'@BeginDate=:BeginDate,'#13#10'@EndDate' +
      '=:EndDate,'#13#10'@DeptID=:DeptID,'#13#10'@StockID=:StockID,'#13#10'@ProductCode=:' +
      'ProductCode'
    Parameters = <
      item
        Name = 'BeginDate'
        Attributes = [paNullable]
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end
      item
        Name = 'EndDate'
        Attributes = [paNullable]
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end
      item
        Name = 'DeptID'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end
      item
        Name = 'StockID'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end
      item
        Name = 'ProductCode'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 50
        Value = Null
      end>
    object adsMasterID: TIntegerField
      DisplayLabel = #20027#38190'ID'
      FieldName = 'ID'
    end
    object adsMasterSupplyID: TStringField
      DisplayLabel = #25552#36135#21333#20301'ID'
      FieldName = 'SupplyID'
    end
    object adsMasterSupplyShortName: TStringField
      DisplayLabel = #25552#36135#21333#20301
      FieldName = 'SupplyShortName'
      Size = 80
    end
    object adsMasterStockID: TStringField
      DisplayLabel = #20179#24211'ID'
      FieldName = 'StockID'
    end
    object adsMasterStockName: TStringField
      DisplayLabel = #20179#24211
      FieldName = 'StockName'
      Size = 50
    end
    object adsMasterRuleChildID: TStringField
      DisplayLabel = #35268#21017'ID'
      FieldName = 'RuleChildID'
    end
    object adsMasterProductCode: TStringField
      DisplayLabel = #20135#21697#32534#30721
      FieldName = 'ProductCode'
      Size = 50
    end
    object adsMasterProductName: TStringField
      DisplayLabel = #20135#21697#21517#31216
      FieldName = 'ProductName'
      Size = 100
    end
    object adsMasterSpecs: TStringField
      DisplayLabel = #22411#21495#35268#26684
      FieldName = 'Specs'
      Size = 1000
    end
    object adsMasterBatchNo: TStringField
      DisplayLabel = #25209#21495
      FieldName = 'BatchNo'
      Size = 50
    end
    object adsMasterColorCode: TStringField
      DisplayLabel = #33394#21495
      FieldName = 'ColorCode'
      Size = 50
    end
    object adsMasterColorName: TStringField
      DisplayLabel = #39068#33394
      FieldName = 'ColorName'
      Size = 50
    end
    object adsMasterGradeID: TStringField
      DisplayLabel = #31561#32423
      FieldName = 'GradeID'
      Size = 50
    end
    object adsMasterBillDate: TDateTimeField
      DisplayLabel = #21457#29983#26085#26399
      FieldName = 'BillDate'
    end
    object adsMasterBillNo: TStringField
      DisplayLabel = #21333#25454#32534#21495
      FieldName = 'BillNo'
    end
    object adsMasterBillType: TIntegerField
      DisplayLabel = #19994#21153#31867#22411'ID'
      FieldName = 'BillType'
    end
    object adsMasterBillTypeName: TStringField
      DisplayLabel = #19994#21153#31867#22411
      FieldName = 'BillTypeName'
    end
    object adsMasterInNumber: TFloatField
      DisplayLabel = #25910#20837'|'#25968#37327
      FieldName = 'InNumber'
    end
    object adsMasterInPrice: TFloatField
      DisplayLabel = #25910#20837'|'#21333#20215
      FieldName = 'InPrice'
    end
    object adsMasterInMoney: TFloatField
      DisplayLabel = #25910#20837'|'#37329#39069
      FieldName = 'InMoney'
    end
    object adsMasterOutNumber: TFloatField
      DisplayLabel = #21457#20986'|'#25968#37327
      FieldName = 'OutNumber'
    end
    object adsMasterOutPrice: TFloatField
      DisplayLabel = #21457#20986'|'#21333#20215
      FieldName = 'OutPrice'
    end
    object adsMasterOutMoney: TFloatField
      DisplayLabel = #21457#20986'|'#37329#39069
      FieldName = 'OutMoney'
    end
    object adsMasterSumNumber: TFloatField
      DisplayLabel = #32467#23384'|'#25968#37327
      FieldName = 'SumNumber'
    end
    object adsMasterSumMoney: TFloatField
      DisplayLabel = #32467#23384'|'#37329#39069
      FieldName = 'SumMoney'
    end
    object adsMasterUnitID: TStringField
      DisplayLabel = #21333#20301'ID'
      FieldName = 'UnitID'
    end
    object adsMasterUnitName: TStringField
      DisplayLabel = #21333#20301
      FieldName = 'UnitName'
      Size = 10
    end
    object adsMasterKeyFieldName: TStringField
      FieldName = 'KeyFieldName'
    end
    object adsMasterFormClassName: TStringField
      FieldName = 'FormClassName'
      Size = 80
    end
  end
  inherited adsMasterEdit: TADODataSet
    CursorType = ctStatic
  end
  object adsUserCompany: TADODataSet
    Connection = dtmConnect.conMain
    LockType = ltBatchOptimistic
    CommandText = 
      'select b.DeptID, b.DeptCode, b.DeptName from xt_CompanySet a '#13#10'j' +
      'oin da_Department b on a.CompanyID=b.DeptID'#13#10'where a.UserID=(sel' +
      'ect UserID from xt_Users where UserCode=:UserCode)'
    Parameters = <
      item
        Name = 'UserCode'
        Size = -1
        Value = Null
      end>
    Left = 176
    Top = 104
  end
  object adsUserStock: TADODataSet
    Connection = dtmConnect.conMain
    LockType = ltBatchOptimistic
    CommandText = 
      'select b.StockID, b.StockCode, b.StockName from xt_StockSet a '#13#10 +
      'join da_Stock b on a.StockID=b.StockID'#13#10'where b.DeptID=:DeptID'#13#10 +
      ' and a.UserID=(select UserID from xt_Users where UserCode=:UserC' +
      'ode)'#13#10' and isnull(b.StockType,0)=12 and isnull(b.HasStop,0)=0'
    Parameters = <
      item
        Name = 'DeptID'
        Size = -1
        Value = Null
      end
      item
        Name = 'UserCode'
        Size = -1
        Value = Null
      end>
    Left = 176
    Top = 40
  end
  object adsProductType: TADODataSet
    Connection = dtmConnect.conMain
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandText = 'select * from V_da_ProductType order by RuleChildID'
    Parameters = <>
    Left = 176
    Top = 168
  end
end
